Overview

Brought to you by YData

Dataset statistics

Number of variables	31
Number of observations	346018
Missing cells	1565549
Missing cells (%)	14.6%
Duplicate rows	1302
Duplicate rows (%)	0.4%
Total size in memory	81.8 MiB
Average record size in memory	248.0 B

Variable types

DateTime	1
Text	18
Categorical	5
Numeric	6
Boolean	1

Alerts

Dataset has 1302 (0.4%) duplicate rows	Duplicates
`Sub-Acquisition Method` is highly imbalanced (51.4%)	Imbalance
`CalCard` is highly imbalanced (88.4%)	Imbalance
`Purchase Date` has 17436 (5.0%) missing values	Missing
`LPA Number` has 253673 (73.3%) missing values	Missing
`Requisition Number` has 331649 (95.8%) missing values	Missing
`Sub-Acquisition Type` has 277681 (80.3%) missing values	Missing
`Sub-Acquisition Method` has 315122 (91.1%) missing values	Missing
`Supplier Qualifications` has 204273 (59.0%) missing values	Missing
`Supplier Zip Code` has 70110 (20.3%) missing values	Missing
`Location` has 70110 (20.3%) missing values	Missing
`Supplier Code` is highly skewed (γ1 = 343.4821729)	Skewed
`Quantity` is highly skewed (γ1 = 117.4482872)	Skewed
`Supplier Code` has 4473 (1.3%) zeros	Zeros

Reproduction

Analysis started	2024-12-15 13:19:07.417860
Analysis finished	2024-12-15 13:19:54.971040
Duration	47.55 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

Creation Date
Date

Distinct	1015
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Minimum	2012-07-02 00:00:00
Maximum	2015-06-30 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Purchase Date
Text

Missing

Distinct	2268
Distinct (%)	0.7%
Missing	17436
Missing (%)	5.0%
Memory size	2.6 MiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	3285820
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	328 ?
Unique (%)	0.1%

Sample

1st row	06/05/2014
2nd row	03/12/2014
3rd row	10/01/2014
4th row	04/14/2014
5th row	07/26/2013

Value	Count	Frequency (%)
07/01/2014	4499	1.4%
07/01/2013	4462	1.4%
07/01/2015	2755	0.8%
07/01/2012	2218	0.7%
05/01/2013	1221	0.4%
05/27/2014	1126	0.3%
06/05/2013	1117	0.3%
09/25/2013	1072	0.3%
03/25/2014	1018	0.3%
06/30/2015	1006	0.3%
Other values (2258)	308088	93.8%

Most occurring characters

Value	Count	Frequency (%)
0	754765	23.0%
/	657164	20.0%
1	597757	18.2%
2	559696	17.0%
3	180341	5.5%
4	164978	5.0%
5	120727	3.7%
6	68665	2.1%
7	64861	2.0%
9	59012	1.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3285820	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	754765	23.0%
/	657164	20.0%
1	597757	18.2%
2	559696	17.0%
3	180341	5.5%
4	164978	5.0%
5	120727	3.7%
6	68665	2.1%
7	64861	2.0%
9	59012	1.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3285820	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	754765	23.0%
/	657164	20.0%
1	597757	18.2%
2	559696	17.0%
3	180341	5.5%
4	164978	5.0%
5	120727	3.7%
6	68665	2.1%
7	64861	2.0%
9	59012	1.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3285820	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	754765	23.0%
/	657164	20.0%
1	597757	18.2%
2	559696	17.0%
3	180341	5.5%
4	164978	5.0%
5	120727	3.7%
6	68665	2.1%
7	64861	2.0%
9	59012	1.8%

Fiscal Year
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

2013-2014	120636
2014-2015	116537
2012-2013	108845

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	3114162
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2013-2014
2nd row	2013-2014
3rd row	2013-2014
4th row	2013-2014
5th row	2013-2014

Common Values

Value	Count	Frequency (%)
2013-2014	120636	34.9%
2014-2015	116537	33.7%
2012-2013	108845	31.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2013-2014	120636	34.9%
2014-2015	116537	33.7%
2012-2013	108845	31.5%

Most occurring characters

Value	Count	Frequency (%)
2	800881	25.7%
0	692036	22.2%
1	692036	22.2%
-	346018	11.1%
4	237173	7.6%
3	229481	7.4%
5	116537	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3114162	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	800881	25.7%
0	692036	22.2%
1	692036	22.2%
-	346018	11.1%
4	237173	7.6%
3	229481	7.4%
5	116537	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3114162	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	800881	25.7%
0	692036	22.2%
1	692036	22.2%
-	346018	11.1%
4	237173	7.6%
3	229481	7.4%
5	116537	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3114162	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	800881	25.7%
0	692036	22.2%
1	692036	22.2%
-	346018	11.1%
4	237173	7.6%
3	229481	7.4%
5	116537	3.7%

LPA Number
Text

Missing

Distinct	1420
Distinct (%)	1.5%
Missing	253673
Missing (%)	73.3%
Memory size	2.6 MiB

Length

Max length	16
Median length	15
Mean length	11.036104
Min length	2

Characters and Unicode

Total characters	1019129
Distinct characters	44
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	399 ?
Unique (%)	0.4%

Sample

1st row	7-12-70-26
2nd row	1-10-75-60A
3rd row	1-14-75-60A
4th row	1-14-75-60A
5th row	SBP01337

Value	Count	Frequency (%)
7-11-51-02	9267	8.9%
	4105	3.9%
1-10-75-60a	3763	3.6%
1-12-65-65-01-e	3717	3.6%
a	3243	3.1%
g	3229	3.1%
1-11-70-04o	3097	3.0%
1-13-70-02a	2612	2.5%
1-11-70-04q	2481	2.4%
1-13-70-01a	2098	2.0%
Other values (1415)	67064	64.1%

Most occurring characters

Value	Count	Frequency (%)
-	281197	27.6%
1	210038	20.6%
0	125737	12.3%
7	62873	6.2%
5	52827	5.2%
2	50578	5.0%
3	40364	4.0%
9	31213	3.1%
4	30075	3.0%
6	29901	2.9%
Other values (34)	104326	10.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1019129	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
-	281197	27.6%
1	210038	20.6%
0	125737	12.3%
7	62873	6.2%
5	52827	5.2%
2	50578	5.0%
3	40364	4.0%
9	31213	3.1%
4	30075	3.0%
6	29901	2.9%
Other values (34)	104326	10.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1019129	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
-	281197	27.6%
1	210038	20.6%
0	125737	12.3%
7	62873	6.2%
5	52827	5.2%
2	50578	5.0%
3	40364	4.0%
9	31213	3.1%
4	30075	3.0%
6	29901	2.9%
Other values (34)	104326	10.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1019129	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
-	281197	27.6%
1	210038	20.6%
0	125737	12.3%
7	62873	6.2%
5	52827	5.2%
2	50578	5.0%
3	40364	4.0%
9	31213	3.1%
4	30075	3.0%
6	29901	2.9%
Other values (34)	104326	10.2%

Purchase Order Number
Text

Distinct	200533
Distinct (%)	58.0%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Length

Max length	32
Median length	31
Mean length	8.969938
Min length	1

Characters and Unicode

Total characters	3103760
Distinct characters	82
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	166350 ?
Unique (%)	48.1%

Sample

1st row	REQ0011118
2nd row	REQ0011932
3rd row	REQ0011476
4th row	4500236642
5th row	4500221028

Value	Count	Frequency (%)
2660	1393	0.4%
prf	930	0.3%
boe	631	0.2%
4500211314	602	0.2%
4500201426	579	0.2%
4500204899	578	0.2%
4500203794	578	0.2%
4500202454	564	0.2%
4500198630	547	0.2%
4500210216	546	0.2%
Other values (199482)	346489	98.0%

Most occurring characters

Value	Count	Frequency (%)
0	664769	21.4%
1	386930	12.5%
4	322860	10.4%
2	295105	9.5%
5	282763	9.1%
3	215362	6.9%
6	152176	4.9%
7	133355	4.3%
8	131526	4.2%
9	124993	4.0%
Other values (72)	393921	12.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3103760	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	664769	21.4%
1	386930	12.5%
4	322860	10.4%
2	295105	9.5%
5	282763	9.1%
3	215362	6.9%
6	152176	4.9%
7	133355	4.3%
8	131526	4.2%
9	124993	4.0%
Other values (72)	393921	12.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3103760	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	664769	21.4%
1	386930	12.5%
4	322860	10.4%
2	295105	9.5%
5	282763	9.1%
3	215362	6.9%
6	152176	4.9%
7	133355	4.3%
8	131526	4.2%
9	124993	4.0%
Other values (72)	393921	12.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3103760	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	664769	21.4%
1	386930	12.5%
4	322860	10.4%
2	295105	9.5%
5	282763	9.1%
3	215362	6.9%
6	152176	4.9%
7	133355	4.3%
8	131526	4.2%
9	124993	4.0%
Other values (72)	393921	12.7%

Requisition Number
Text

Missing

Distinct	5997
Distinct (%)	41.7%
Missing	331649
Missing (%)	95.8%
Memory size	2.6 MiB

Length

Max length	11
Median length	10
Mean length	9.9869859
Min length	4

Characters and Unicode

Total characters	143503
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4023 ?
Unique (%)	28.0%

Sample

1st row	REQ0011118
2nd row	REQ0011932
3rd row	REQ0011476
4th row	REQ0013911
5th row	REQ0014515

Value	Count	Frequency (%)
req0008872	123	0.9%
req0010655	81	0.6%
req0009177	65	0.5%
req0010201	62	0.4%
req0008985	59	0.4%
req0008405	55	0.4%
req0010705	51	0.4%
req0009336	51	0.4%
req0010418	49	0.3%
req0010689	39	0.3%
Other values (5984)	13734	95.6%

Most occurring characters

Value	Count	Frequency (%)
0	38895	27.1%
1	17527	12.2%
R	14323	10.0%
E	14075	9.8%
Q	14023	9.8%
9	6459	4.5%
2	6183	4.3%
3	6070	4.2%
4	5547	3.9%
8	4991	3.5%
Other values (31)	15410	10.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	143503	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	38895	27.1%
1	17527	12.2%
R	14323	10.0%
E	14075	9.8%
Q	14023	9.8%
9	6459	4.5%
2	6183	4.3%
3	6070	4.2%
4	5547	3.9%
8	4991	3.5%
Other values (31)	15410	10.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	143503	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	38895	27.1%
1	17527	12.2%
R	14323	10.0%
E	14075	9.8%
Q	14023	9.8%
9	6459	4.5%
2	6183	4.3%
3	6070	4.2%
4	5547	3.9%
8	4991	3.5%
Other values (31)	15410	10.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	143503	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	38895	27.1%
1	17527	12.2%
R	14323	10.0%
E	14075	9.8%
Q	14023	9.8%
9	6459	4.5%
2	6183	4.3%
3	6070	4.2%
4	5547	3.9%
8	4991	3.5%
Other values (31)	15410	10.7%

Acquisition Type
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

NON-IT Goods	215083
NON-IT Services	68372
IT Goods	50900
IT Services	11516
IT Telecommunications	147

Length

Max length	21
Median length	12
Mean length	11.974923
Min length	8

Characters and Unicode

Total characters	4143539
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IT Goods
2nd row	NON-IT Goods
3rd row	IT Services
4th row	NON-IT Goods
5th row	NON-IT Goods

Common Values

Value	Count	Frequency (%)
NON-IT Goods	215083	62.2%
NON-IT Services	68372	19.8%
IT Goods	50900	14.7%
IT Services	11516	3.3%
IT Telecommunications	147	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
non-it	283455	41.0%
goods	265983	38.4%
services	79888	11.5%
it	62563	9.0%
telecommunications	147	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	566910	13.7%
o	532260	12.8%
T	346165	8.4%
I	346018	8.4%
	346018	8.4%
s	346018	8.4%
O	283455	6.8%
-	283455	6.8%
G	265983	6.4%
d	265983	6.4%
Other values (12)	561274	13.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4143539	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	566910	13.7%
o	532260	12.8%
T	346165	8.4%
I	346018	8.4%
	346018	8.4%
s	346018	8.4%
O	283455	6.8%
-	283455	6.8%
G	265983	6.4%
d	265983	6.4%
Other values (12)	561274	13.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4143539	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	566910	13.7%
o	532260	12.8%
T	346165	8.4%
I	346018	8.4%
	346018	8.4%
s	346018	8.4%
O	283455	6.8%
-	283455	6.8%
G	265983	6.4%
d	265983	6.4%
Other values (12)	561274	13.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4143539	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	566910	13.7%
o	532260	12.8%
T	346165	8.4%
I	346018	8.4%
	346018	8.4%
s	346018	8.4%
O	283455	6.8%
-	283455	6.8%
G	265983	6.4%
d	265983	6.4%
Other values (12)	561274	13.5%

Sub-Acquisition Type
Categorical

Missing

Distinct	25
Distinct (%)	< 0.1%
Missing	277681
Missing (%)	80.3%
Memory size	2.6 MiB

Personal Services	16104
Services are specifically exempt by statute	11854
Emergency Contract	7913
Subvention and Local Assistance	7048
Public Works	4791
Other values (20)	20627

Length

Max length	67
Median length	43
Mean length	25.958397
Min length	11

Characters and Unicode

Total characters	1773919
Distinct characters	44
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Personal Services
2nd row	Personal Services
3rd row	Legal Services
4th row	Legal Services
5th row	Legal Services

Common Values

Value	Count	Frequency (%)
Personal Services	16104	4.7%
Services are specifically exempt by statute	11854	3.4%
Emergency Contract	7913	2.3%
Subvention and Local Assistance	7048	2.0%
Public Works	4791	1.4%
Expert Witneses	3800	1.1%
Interagency Agreements	3261	0.9%
Agreements with other governmental entities and public universities	2051	0.6%
Architectural and Engineering	1785	0.5%
Contracts with Local Governments	1562	0.5%
Other values (15)	8168	2.4%
(Missing)	277681	80.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
services	32201	14.4%
personal	16104	7.2%
and	12477	5.6%
are	11854	5.3%
specifically	11854	5.3%
exempt	11854	5.3%
by	11854	5.3%
statute	11854	5.3%
local	8610	3.9%
emergency	7913	3.5%
Other values (51)	87054	38.9%

Most occurring characters

Value	Count	Frequency (%)
e	237220	13.4%
	155292	8.8%
s	127181	7.2%
t	125370	7.1%
n	115940	6.5%
i	115867	6.5%
r	115471	6.5%
a	105019	5.9%
c	103985	5.9%
l	65656	3.7%
Other values (34)	506918	28.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1773919	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	237220	13.4%
	155292	8.8%
s	127181	7.2%
t	125370	7.1%
n	115940	6.5%
i	115867	6.5%
r	115471	6.5%
a	105019	5.9%
c	103985	5.9%
l	65656	3.7%
Other values (34)	506918	28.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1773919	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	237220	13.4%
	155292	8.8%
s	127181	7.2%
t	125370	7.1%
n	115940	6.5%
i	115867	6.5%
r	115471	6.5%
a	105019	5.9%
c	103985	5.9%
l	65656	3.7%
Other values (34)	506918	28.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1773919	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	237220	13.4%
	155292	8.8%
s	127181	7.2%
t	125370	7.1%
n	115940	6.5%
i	115867	6.5%
r	115471	6.5%
a	105019	5.9%
c	103985	5.9%
l	65656	3.7%
Other values (34)	506918	28.6%

Acquisition Method
Categorical

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Informal Competitive	82083
Statewide Contract	63488
SB/DVBE Option	38500
Services are specifically exempt by statute	33045
State Programs	27842
Other values (15)	101060

Length

Max length	43
Median length	42
Mean length	20.229682
Min length	3

Characters and Unicode

Total characters	6999834
Distinct characters	44
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WSCA/Coop
2nd row	Informal Competitive
3rd row	Informal Competitive
4th row	Informal Competitive
5th row	Statewide Contract

Common Values

Value	Count	Frequency (%)
Informal Competitive	82083	23.7%
Statewide Contract	63488	18.3%
SB/DVBE Option	38500	11.1%
Services are specifically exempt by statute	33045	9.6%
State Programs	27842	8.0%
Fair and Reasonable	25400	7.3%
WSCA/Coop	19478	5.6%
Formal Competitive	18479	5.3%
Services are specifically exempt by policy	11302	3.3%
Emergency Purchase	10186	2.9%
Other values (10)	16215	4.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
competitive	100562	11.5%
informal	82083	9.4%
statewide	63488	7.3%
contract	63488	7.3%
are	44347	5.1%
exempt	44347	5.1%
specifically	44347	5.1%
by	44347	5.1%
services	44347	5.1%
option	38500	4.4%
Other values (32)	304130	34.8%

Most occurring characters

Value	Count	Frequency (%)
e	769414	11.0%
t	706065	10.1%
a	529084	7.6%
	527968	7.5%
i	481038	6.9%
o	412281	5.9%
r	373842	5.3%
m	289832	4.1%
p	259213	3.7%
n	251937	3.6%
Other values (34)	2399160	34.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6999834	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	769414	11.0%
t	706065	10.1%
a	529084	7.6%
	527968	7.5%
i	481038	6.9%
o	412281	5.9%
r	373842	5.3%
m	289832	4.1%
p	259213	3.7%
n	251937	3.6%
Other values (34)	2399160	34.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6999834	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	769414	11.0%
t	706065	10.1%
a	529084	7.6%
	527968	7.5%
i	481038	6.9%
o	412281	5.9%
r	373842	5.3%
m	289832	4.1%
p	259213	3.7%
n	251937	3.6%
Other values (34)	2399160	34.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6999834	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	769414	11.0%
t	706065	10.1%
a	529084	7.6%
	527968	7.5%
i	481038	6.9%
o	412281	5.9%
r	373842	5.3%
m	289832	4.1%
p	259213	3.7%
n	251937	3.6%
Other values (34)	2399160	34.3%

Sub-Acquisition Method
Categorical

Imbalance Missing

Distinct	16
Distinct (%)	0.1%
Missing	315122
Missing (%)	91.1%
Memory size	2.6 MiB

Fleet	14148
Prison Industry Authority (PIA)	11602
Only goods and services that meet needs of the State	1810
Office of State Printing (OSP)	812
Interagency Agreement	565
Other values (11)	1959

Length

Max length	58
Median length	56
Mean length	20.272333
Min length	5

Characters and Unicode

Total characters	626334
Distinct characters	43
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Other
2nd row	Prison Industry Authority (PIA)
3rd row	Prison Industry Authority (PIA)
4th row	Prison Industry Authority (PIA)
5th row	Prison Industry Authority (PIA)

Common Values

Value	Count	Frequency (%)
Fleet	14148	4.1%
Prison Industry Authority (PIA)	11602	3.4%
Only goods and services that meet needs of the State	1810	0.5%
Office of State Printing (OSP)	812	0.2%
Interagency Agreement	565	0.2%
Services are specifically exempt by statute	521	0.2%
Other	503	0.1%
Emergency acquisition for the protection of the public	334	0.1%
A single firm services a geographic region	328	0.1%
Contract with other government agency	117	< 0.1%
Other values (6)	156	< 0.1%
(Missing)	315122	91.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fleet	14148	15.1%
authority	11602	12.4%
pia	11602	12.4%
prison	11602	12.4%
industry	11602	12.4%
of	2956	3.2%
services	2677	2.9%
state	2622	2.8%
the	2478	2.6%
and	1810	1.9%
Other values (50)	20502	21.9%

Most occurring characters

Value	Count	Frequency (%)
t	68653	11.0%
	62705	10.0%
e	55519	8.9%
r	42991	6.9%
n	34477	5.5%
s	33452	5.3%
i	32734	5.2%
o	32392	5.2%
y	27164	4.3%
P	24828	4.0%
Other values (33)	211419	33.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	626334	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	68653	11.0%
	62705	10.0%
e	55519	8.9%
r	42991	6.9%
n	34477	5.5%
s	33452	5.3%
i	32734	5.2%
o	32392	5.2%
y	27164	4.3%
P	24828	4.0%
Other values (33)	211419	33.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	626334	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	68653	11.0%
	62705	10.0%
e	55519	8.9%
r	42991	6.9%
n	34477	5.5%
s	33452	5.3%
i	32734	5.2%
o	32392	5.2%
y	27164	4.3%
P	24828	4.0%
Other values (33)	211419	33.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	626334	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	68653	11.0%
	62705	10.0%
e	55519	8.9%
r	42991	6.9%
n	34477	5.5%
s	33452	5.3%
i	32734	5.2%
o	32392	5.2%
y	27164	4.3%
P	24828	4.0%
Other values (33)	211419	33.8%

Department Name
Text

Distinct	111
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.6 MiB

Length

Max length	59
Median length	51
Mean length	34.360594
Min length	17

Characters and Unicode

Total characters	11889384
Distinct characters	50
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	Consumer Affairs, Department of
2nd row	Consumer Affairs, Department of
3rd row	Consumer Affairs, Department of
4th row	Correctional Health Care Services
5th row	Corrections and Rehabilitation, Department of

Value	Count	Frequency (%)
of	272314	18.4%
department	265129	17.9%
and	95652	6.5%
services	63459	4.3%
rehabilitation	59821	4.0%
corrections	57557	3.9%
health	49030	3.3%
care	35715	2.4%
resources	33370	2.3%
correctional	32250	2.2%
Other values (171)	515655	34.8%

Most occurring characters

Value	Count	Frequency (%)
e	1355089	11.4%
t	1140741	9.6%
	1133934	9.5%
a	932131	7.8%
r	907190	7.6%
o	849147	7.1%
n	769164	6.5%
i	659960	5.6%
s	390801	3.3%
f	359306	3.0%
Other values (40)	3391921	28.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	11889384	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1355089	11.4%
t	1140741	9.6%
	1133934	9.5%
a	932131	7.8%
r	907190	7.6%
o	849147	7.1%
n	769164	6.5%
i	659960	5.6%
s	390801	3.3%
f	359306	3.0%
Other values (40)	3391921	28.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	11889384	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1355089	11.4%
t	1140741	9.6%
	1133934	9.5%
a	932131	7.8%
r	907190	7.6%
o	849147	7.1%
n	769164	6.5%
i	659960	5.6%
s	390801	3.3%
f	359306	3.0%
Other values (40)	3391921	28.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	11889384	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1355089	11.4%
t	1140741	9.6%
	1133934	9.5%
a	932131	7.8%
r	907190	7.6%
o	849147	7.1%
n	769164	6.5%
i	659960	5.6%
s	390801	3.3%
f	359306	3.0%
Other values (40)	3391921	28.5%

Supplier Code
Real number (ℝ)

Skewed Zeros

Distinct	25239
Distinct (%)	7.3%
Missing	36
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	843434.48

Minimum	0
Maximum	9.5483178 × 10⁸
Zeros	4473
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0
5-th percentile	6509
Q1	27292
median	1012531
Q3	1482180
95-th percentile	1757013
Maximum	9.5483178 × 10⁸
Range	9.5483178 × 10⁸
Interquartile range (IQR)	1454888

Descriptive statistics

Standard deviation	2461186.2
Coefficient of variation (CV)	2.9180526
Kurtosis	131365.99
Mean	843434.48
Median Absolute Deviation (MAD)	738209
Skewness	343.48217
Sum	2.9181315 × 10¹¹
Variance	6.0574375 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1743406	13756	4.0%
1001584	9441	2.7%
1065902	8508	2.5%
1008361	6991	2.0%
1087660	6709	1.9%
17224	5979	1.7%
1755386	5033	1.5%
0	4473	1.3%
12341	3983	1.2%
1752319	3625	1.0%
Other values (25229)	277484	80.2%

Value	Count	Frequency (%)
0	4473	1.3%
15	2	< 0.1%
39	377	0.1%
42	3	< 0.1%
45	1	< 0.1%
49	1	< 0.1%
61	69	< 0.1%
89	8	< 0.1%
114	1	< 0.1%
123	1	< 0.1%

Value	Count	Frequency (%)
954831781	1	< 0.1%
954650312	1	< 0.1%
330284668	1	< 0.1%
1796774	6	< 0.1%
1796486	8	< 0.1%
1795780	4	< 0.1%
1795272	10	< 0.1%
1794552	4	< 0.1%
1794147	9	< 0.1%
1793858	1	< 0.1%

Supplier Name
Text

Distinct	24732
Distinct (%)	7.1%
Missing	36
Missing (%)	< 0.1%
Memory size	2.6 MiB

Length

Max length	80
Median length	72
Mean length	23.540043
Min length	3

Characters and Unicode

Total characters	8144431
Distinct characters	86
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10435 ?
Unique (%)	3.0%

Sample

1st row	Pitney Bowes
2nd row	Rodea Auto Tech
3rd row	Smile Business Products, Inc
4th row	ASHAN INC
5th row	Technology Integration Group

Value	Count	Frequency (%)
inc	124185	10.8%
supply	26861	2.3%
systems	23263	2.0%
	20226	1.8%
group	14933	1.3%
industrial	14889	1.3%
of	14740	1.3%
office	14500	1.3%
fleet	14274	1.2%
business	14114	1.2%
Other values (18509)	872395	75.6%

Most occurring characters

Value	Count	Frequency (%)
	808663	9.9%
e	514076	6.3%
n	495074	6.1%
r	394831	4.8%
o	393995	4.8%
i	381051	4.7%
t	377055	4.6%
s	345353	4.2%
a	324608	4.0%
I	295467	3.6%
Other values (76)	3814258	46.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8144431	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	808663	9.9%
e	514076	6.3%
n	495074	6.1%
r	394831	4.8%
o	393995	4.8%
i	381051	4.7%
t	377055	4.6%
s	345353	4.2%
a	324608	4.0%
I	295467	3.6%
Other values (76)	3814258	46.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8144431	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	808663	9.9%
e	514076	6.3%
n	495074	6.1%
r	394831	4.8%
o	393995	4.8%
i	381051	4.7%
t	377055	4.6%
s	345353	4.2%
a	324608	4.0%
I	295467	3.6%
Other values (76)	3814258	46.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8144431	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	808663	9.9%
e	514076	6.3%
n	495074	6.1%
r	394831	4.8%
o	393995	4.8%
i	381051	4.7%
t	377055	4.6%
s	345353	4.2%
a	324608	4.0%
I	295467	3.6%
Other values (76)	3814258	46.8%

Supplier Qualifications
Text

Missing

Distinct	278
Distinct (%)	0.2%
Missing	204273
Missing (%)	59.0%
Memory size	2.6 MiB

Length

Max length	62
Median length	57
Mean length	12.242287
Min length	2

Characters and Unicode

Total characters	1735283
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	62 ?
Unique (%)	< 0.1%

Sample

1st row	CA-MB CA-SB
2nd row	CA-MB CA-SB
3rd row	CA-DVBE CA-MB CA-SB CDVBE
4th row	CA-SB
5th row	CA-MB CA-SB

Value	Count	Frequency (%)
ca-sb	133608	42.6%
ca-mb	79876	25.5%
ca-sbe	29408	9.4%
ca-dvbe	21146	6.7%
sb	19399	6.2%
cdvbe	11313	3.6%
wbe	4519	1.4%
sdvosb	3219	1.0%
wosb	3003	1.0%
mbe	2708	0.9%
Other values (6)	5170	1.6%

Most occurring characters

Value	Count	Frequency (%)
B	312875	18.0%
C	276125	15.9%
A	265092	15.3%
-	264812	15.3%
S	194049	11.2%
	171624	9.9%
M	84217	4.9%
E	71577	4.1%
D	38441	2.2%
V	36661	2.1%
Other values (8)	19810	1.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1735283	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
B	312875	18.0%
C	276125	15.9%
A	265092	15.3%
-	264812	15.3%
S	194049	11.2%
	171624	9.9%
M	84217	4.9%
E	71577	4.1%
D	38441	2.2%
V	36661	2.1%
Other values (8)	19810	1.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1735283	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
B	312875	18.0%
C	276125	15.9%
A	265092	15.3%
-	264812	15.3%
S	194049	11.2%
	171624	9.9%
M	84217	4.9%
E	71577	4.1%
D	38441	2.2%
V	36661	2.1%
Other values (8)	19810	1.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1735283	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
B	312875	18.0%
C	276125	15.9%
A	265092	15.3%
-	264812	15.3%
S	194049	11.2%
	171624	9.9%
M	84217	4.9%
E	71577	4.1%
D	38441	2.2%
V	36661	2.1%
Other values (8)	19810	1.1%

Supplier Zip Code
Text

Missing

Distinct	3993
Distinct (%)	1.4%
Missing	70110
Missing (%)	20.3%
Memory size	2.6 MiB

Length

Max length	12
Median length	5
Mean length	5.1999906
Min length	3

Characters and Unicode

Total characters	1434719
Distinct characters	41
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	742 ?
Unique (%)	0.3%

Sample

1st row	95841
2nd row	91436
3rd row	95814
4th row	97008
5th row	95814

Value	Count	Frequency (%)
95691	11095	4.0%
95814	10921	4.0%
95696	8518	3.1%
95827	7159	2.6%
95841	7008	2.5%
73529	6991	2.5%
95742	5676	2.1%
95811	4779	1.7%
93706	4412	1.6%
92653	4027	1.5%
Other values (4007)	205462	74.4%

Most occurring characters

Value	Count	Frequency (%)
9	305406	21.3%
5	193463	13.5%
1	149128	10.4%
6	129810	9.0%
0	126572	8.8%
2	118545	8.3%
3	110956	7.7%
4	105718	7.4%
8	93727	6.5%
7	88950	6.2%
Other values (31)	12444	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1434719	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
9	305406	21.3%
5	193463	13.5%
1	149128	10.4%
6	129810	9.0%
0	126572	8.8%
2	118545	8.3%
3	110956	7.7%
4	105718	7.4%
8	93727	6.5%
7	88950	6.2%
Other values (31)	12444	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1434719	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
9	305406	21.3%
5	193463	13.5%
1	149128	10.4%
6	129810	9.0%
0	126572	8.8%
2	118545	8.3%
3	110956	7.7%
4	105718	7.4%
8	93727	6.5%
7	88950	6.2%
Other values (31)	12444	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1434719	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
9	305406	21.3%
5	193463	13.5%
1	149128	10.4%
6	129810	9.0%
0	126572	8.8%
2	118545	8.3%
3	110956	7.7%
4	105718	7.4%
8	93727	6.5%
7	88950	6.2%
Other values (31)	12444	0.9%

CalCard
Boolean

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	338.0 KiB

False	340646
True	5372

Value	Count	Frequency (%)
False	340646	98.4%
True	5372	1.6%

Item Name
Text

Distinct	180029
Distinct (%)	52.0%
Missing	32
Missing (%)	< 0.1%
Memory size	2.6 MiB

Length

Max length	101
Median length	81
Mean length	22.547808
Min length	1

Characters and Unicode

Total characters	7801226
Distinct characters	123
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	151218 ?
Unique (%)	43.7%

Sample

1st row	USB
2nd row	Tire Disposal
3rd row	Labor
4th row	Toner
5th row	HP 35A BLACK TONER

Value	Count	Frequency (%)
for	24932	2.2%
	17809	1.5%
services	15568	1.3%
equip	13811	1.2%
fuel	13340	1.2%
and	12349	1.1%
supplies	11452	1.0%
maintenance	9254	0.8%
medical	7579	0.7%
hp	7018	0.6%
Other values (82436)	1025214	88.5%

Most occurring characters

Value	Count	Frequency (%)
	815972	10.5%
e	573975	7.4%
r	378780	4.9%
a	370956	4.8%
i	356300	4.6%
n	319439	4.1%
t	317283	4.1%
o	304368	3.9%
s	253119	3.2%
l	229373	2.9%
Other values (113)	3881661	49.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7801226	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	815972	10.5%
e	573975	7.4%
r	378780	4.9%
a	370956	4.8%
i	356300	4.6%
n	319439	4.1%
t	317283	4.1%
o	304368	3.9%
s	253119	3.2%
l	229373	2.9%
Other values (113)	3881661	49.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7801226	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	815972	10.5%
e	573975	7.4%
r	378780	4.9%
a	370956	4.8%
i	356300	4.6%
n	319439	4.1%
t	317283	4.1%
o	304368	3.9%
s	253119	3.2%
l	229373	2.9%
Other values (113)	3881661	49.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7801226	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	815972	10.5%
e	573975	7.4%
r	378780	4.9%
a	370956	4.8%
i	356300	4.6%
n	319439	4.1%
t	317283	4.1%
o	304368	3.9%
s	253119	3.2%
l	229373	2.9%
Other values (113)	3881661	49.8%

Item Description
Text

Distinct	219508
Distinct (%)	63.5%
Missing	202
Missing (%)	0.1%
Memory size	2.6 MiB

Length

Max length	3380
Median length	1707
Mean length	41.868366
Min length	1

Characters and Unicode

Total characters	14478751
Distinct characters	131
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	195325 ?
Unique (%)	56.5%

Sample

1st row	USB
2nd row	Tire Disposal
3rd row	Labor
4th row	Toner
5th row	HP 35A BLACK TONER

Value	Count	Frequency (%)
for	53923	2.5%
and	42931	2.0%
the	34091	1.6%
to	33522	1.6%
	29903	1.4%
of	24985	1.2%
services	20629	1.0%
fuel	13921	0.6%
equip	13819	0.6%
provide	12904	0.6%
Other values (139566)	1877652	87.0%

Most occurring characters

Value	Count	Frequency (%)
	1867193	12.9%
e	1035864	7.2%
a	695956	4.8%
r	682223	4.7%
i	661077	4.6%
t	653680	4.5%
o	627712	4.3%
n	623075	4.3%
s	491782	3.4%
l	396589	2.7%
Other values (121)	6743600	46.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	14478751	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1867193	12.9%
e	1035864	7.2%
a	695956	4.8%
r	682223	4.7%
i	661077	4.6%
t	653680	4.5%
o	627712	4.3%
n	623075	4.3%
s	491782	3.4%
l	396589	2.7%
Other values (121)	6743600	46.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	14478751	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1867193	12.9%
e	1035864	7.2%
a	695956	4.8%
r	682223	4.7%
i	661077	4.6%
t	653680	4.5%
o	627712	4.3%
n	623075	4.3%
s	491782	3.4%
l	396589	2.7%
Other values (121)	6743600	46.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	14478751	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1867193	12.9%
e	1035864	7.2%
a	695956	4.8%
r	682223	4.7%
i	661077	4.6%
t	653680	4.5%
o	627712	4.3%
n	623075	4.3%
s	491782	3.4%
l	396589	2.7%
Other values (121)	6743600	46.6%

Quantity
Real number (ℝ)

Skewed

Distinct	6131
Distinct (%)	1.8%
Missing	30
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2316.1537

Minimum	0.0001
Maximum	20000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	0.0001
5-th percentile	1
Q1	1
median	1
Q3	6
95-th percentile	775
Maximum	20000000
Range	20000000
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	105825.91
Coefficient of variation (CV)	45.690367
Kurtosis	16998.127
Mean	2316.1537
Median Absolute Deviation (MAD)	0
Skewness	117.44829
Sum	8.0136137 × 10⁸
Variance	1.1199123 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	214019	61.9%
2	18383	5.3%
4	8794	2.5%
3	8288	2.4%
10	7053	2.0%
5	6377	1.8%
6	5852	1.7%
20	4108	1.2%
12	3756	1.1%
8	3343	1.0%
Other values (6121)	66015	19.1%

Value	Count	Frequency (%)
0.0001	2	< 0.1%
0.004	1	< 0.1%
0.0055	1	< 0.1%
0.01	5	< 0.1%
0.0102	1	< 0.1%
0.0113	1	< 0.1%
0.1	8	< 0.1%
0.13	1	< 0.1%
0.14	1	< 0.1%
0.18	1	< 0.1%

Value	Count	Frequency (%)
20000000	2	< 0.1%
18000000	1	< 0.1%
15000000	4	< 0.1%
12000000	2	< 0.1%
10000000	1	< 0.1%
9750000	1	< 0.1%
9408000	1	< 0.1%
9000000	2	< 0.1%
8250000	2	< 0.1%
6545000	1	< 0.1%

Unit Price
Text

Distinct	128167
Distinct (%)	37.0%
Missing	30
Missing (%)	< 0.1%
Memory size	2.6 MiB

Length

Max length	14
Median length	12
Mean length	7.3313005
Min length	5

Characters and Unicode

Total characters	2536542
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	99844 ?
Unique (%)	28.9%

Sample

1st row	$1.00
2nd row	$2.00
3rd row	$150.00
4th row	$6080.26
5th row	$45.40

Value	Count	Frequency (%)
0.00	7552	2.2%
1.00	3616	1.0%
10000.00	2207	0.6%
50000.00	1226	0.4%
4.00	1140	0.3%
15000.00	1052	0.3%
20000.00	946	0.3%
30000.00	941	0.3%
25000.00	923	0.3%
1.75	865	0.3%
Other values (127648)	325520	94.1%

Most occurring characters

Value	Count	Frequency (%)
0	560208	22.1%
$	345988	13.6%
.	345988	13.6%
1	198799	7.8%
5	170454	6.7%
2	164405	6.5%
4	133584	5.3%
9	131910	5.2%
3	131539	5.2%
6	122750	4.8%
Other values (3)	230917	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2536542	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	560208	22.1%
$	345988	13.6%
.	345988	13.6%
1	198799	7.8%
5	170454	6.7%
2	164405	6.5%
4	133584	5.3%
9	131910	5.2%
3	131539	5.2%
6	122750	4.8%
Other values (3)	230917	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2536542	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	560208	22.1%
$	345988	13.6%
.	345988	13.6%
1	198799	7.8%
5	170454	6.7%
2	164405	6.5%
4	133584	5.3%
9	131910	5.2%
3	131539	5.2%
6	122750	4.8%
Other values (3)	230917	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2536542	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	560208	22.1%
$	345988	13.6%
.	345988	13.6%
1	198799	7.8%
5	170454	6.7%
2	164405	6.5%
4	133584	5.3%
9	131910	5.2%
3	131539	5.2%
6	122750	4.8%
Other values (3)	230917	9.1%

Total Price
Text

Distinct	150305
Distinct (%)	43.4%
Missing	30
Missing (%)	< 0.1%
Memory size	2.6 MiB

Length

Max length	14
Median length	13
Mean length	7.857391
Min length	5

Characters and Unicode

Total characters	2718563
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	114575 ?
Unique (%)	33.1%

Sample

1st row	$1.00
2nd row	$4.00
3rd row	$675.00
4th row	$6080.26
5th row	$1362.00

Value	Count	Frequency (%)
0.00	7519	2.2%
10000.00	2292	0.7%
50000.00	1265	0.4%
15000.00	1153	0.3%
20000.00	1008	0.3%
30000.00	1005	0.3%
25000.00	969	0.3%
40000.00	696	0.2%
5000.00	685	0.2%
4999.00	616	0.2%
Other values (149654)	328780	95.0%

Most occurring characters

Value	Count	Frequency (%)
0	653196	24.0%
$	345988	12.7%
.	345988	12.7%
1	200334	7.4%
2	180568	6.6%
5	176179	6.5%
4	151616	5.6%
6	140811	5.2%
3	134785	5.0%
8	134106	4.9%
Other values (3)	254992	9.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2718563	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	653196	24.0%
$	345988	12.7%
.	345988	12.7%
1	200334	7.4%
2	180568	6.6%
5	176179	6.5%
4	151616	5.6%
6	140811	5.2%
3	134785	5.0%
8	134106	4.9%
Other values (3)	254992	9.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2718563	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	653196	24.0%
$	345988	12.7%
.	345988	12.7%
1	200334	7.4%
2	180568	6.6%
5	176179	6.5%
4	151616	5.6%
6	140811	5.2%
3	134785	5.0%
8	134106	4.9%
Other values (3)	254992	9.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2718563	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	653196	24.0%
$	345988	12.7%
.	345988	12.7%
1	200334	7.4%
2	180568	6.6%
5	176179	6.5%
4	151616	5.6%
6	140811	5.2%
3	134785	5.0%
8	134106	4.9%
Other values (3)	254992	9.4%

Classification Codes
Text

Distinct	46049
Distinct (%)	13.3%
Missing	1017
Missing (%)	0.3%
Memory size	2.6 MiB

Length

Max length	255
Median length	8
Mean length	13.160913
Min length	6

Characters and Unicode

Total characters	4540528
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	30678 ?
Unique (%)	8.9%

Sample

1st row	76121504
2nd row	44103127
3rd row	44103127
4th row	85121615
5th row	44103127

Value	Count	Frequency (%)
15101506	13313	2.5%
44103103	7628	1.4%
86101605	4802	0.9%
85101705	4297	0.8%
81112201	4151	0.8%
80121903	3680	0.7%
43211503	2807	0.5%
44101501	2611	0.5%
43211507	2558	0.5%
56101504	2551	0.5%
Other values (16967)	494789	91.1%

Most occurring characters

Value	Count	Frequency (%)
1	1288099	28.4%
0	697883	15.4%
2	537533	11.8%
4	403306	8.9%
5	403095	8.9%
3	292989	6.5%
6	229673	5.1%
7	203444	4.5%
	198186	4.4%
8	179319	3.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4540528	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	1288099	28.4%
0	697883	15.4%
2	537533	11.8%
4	403306	8.9%
5	403095	8.9%
3	292989	6.5%
6	229673	5.1%
7	203444	4.5%
	198186	4.4%
8	179319	3.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4540528	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	1288099	28.4%
0	697883	15.4%
2	537533	11.8%
4	403306	8.9%
5	403095	8.9%
3	292989	6.5%
6	229673	5.1%
7	203444	4.5%
	198186	4.4%
8	179319	3.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4540528	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	1288099	28.4%
0	697883	15.4%
2	537533	11.8%
4	403306	8.9%
5	403095	8.9%
3	292989	6.5%
6	229673	5.1%
7	203444	4.5%
	198186	4.4%
8	179319	3.9%

Normalized UNSPSC
Real number (ℝ)

Distinct	13553
Distinct (%)	3.9%
Missing	1017
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	49321974

Minimum	301817
Maximum	95141903
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	301817
5-th percentile	14111703
Q1	39111712
median	44121604
Q3	72101506
95-th percentile	86101705
Maximum	95141903
Range	94840086
Interquartile range (IQR)	32989794

Descriptive statistics

Standard deviation	22469666
Coefficient of variation (CV)	0.4555711
Kurtosis	-0.80910019
Mean	49321974
Median Absolute Deviation (MAD)	12959201
Skewness	0.27843798
Sum	1.701613 × 10¹³
Variance	5.048859 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15101506	12776	3.7%
44103103	7274	2.1%
86101605	4783	1.4%
85101705	4204	1.2%
81112201	3745	1.1%
80121903	3625	1.0%
43211503	2609	0.8%
44101501	2578	0.7%
14111507	2456	0.7%
56101504	2426	0.7%
Other values (13543)	298525	86.3%

Value	Count	Frequency (%)
301817	6	< 0.1%
401723	2	< 0.1%
401726	2	< 0.1%
401728	2	< 0.1%
401729	1	< 0.1%
401733	4	< 0.1%
3018173	1	< 0.1%
10101501	1	< 0.1%
10101502	29	< 0.1%
10101506	39	< 0.1%

Value	Count	Frequency (%)
95141903	289	0.1%
95141902	2	< 0.1%
95141901	4	< 0.1%
95141803	26	< 0.1%
95141802	42	< 0.1%
95141801	12	< 0.1%
95141710	1	< 0.1%
95141708	2	< 0.1%
95141707	1	< 0.1%
95141706	4	< 0.1%

Commodity Title
Text

Distinct	13220
Distinct (%)	3.9%
Missing	3295
Missing (%)	1.0%
Memory size	2.6 MiB

Length

Max length	119
Median length	83
Mean length	24.193153
Min length	2

Characters and Unicode

Total characters	8291550
Distinct characters	74
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3486 ?
Unique (%)	1.0%

Sample

1st row	Jalapeno peppers
2nd row	Ida red apples
3rd row	Magazines
4th row	Hay
5th row	Coffee

Value	Count	Frequency (%)
or	113917	9.9%
services	35130	3.1%
maintenance	15546	1.4%
service	14114	1.2%
gasoline	12806	1.1%
petrol	12776	1.1%
software	11858	1.0%
training	11688	1.0%
printer	11615	1.0%
medical	10148	0.9%
Other values (8077)	900650	78.3%

Most occurring characters

Value	Count	Frequency (%)
e	903605	10.9%
	807525	9.7%
r	683227	8.2%
s	612508	7.4%
i	605481	7.3%
o	561156	6.8%
a	537448	6.5%
t	525956	6.3%
n	487626	5.9%
c	353554	4.3%
Other values (64)	2213464	26.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8291550	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	903605	10.9%
	807525	9.7%
r	683227	8.2%
s	612508	7.4%
i	605481	7.3%
o	561156	6.8%
a	537448	6.5%
t	525956	6.3%
n	487626	5.9%
c	353554	4.3%
Other values (64)	2213464	26.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8291550	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	903605	10.9%
	807525	9.7%
r	683227	8.2%
s	612508	7.4%
i	605481	7.3%
o	561156	6.8%
a	537448	6.5%
t	525956	6.3%
n	487626	5.9%
c	353554	4.3%
Other values (64)	2213464	26.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8291550	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	903605	10.9%
	807525	9.7%
r	683227	8.2%
s	612508	7.4%
i	605481	7.3%
o	561156	6.8%
a	537448	6.5%
t	525956	6.3%
n	487626	5.9%
c	353554	4.3%
Other values (64)	2213464	26.7%

Class
Real number (ℝ)

Distinct	2363
Distinct (%)	0.7%
Missing	3295
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	49276328

Minimum	10101500
Maximum	95141900
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	10101500
5-th percentile	14111700
Q1	39111600
median	44121500
Q3	71161100
95-th percentile	86101700
Maximum	95141900
Range	85040400
Interquartile range (IQR)	32049500

Descriptive statistics

Standard deviation	22461054
Coefficient of variation (CV)	0.45581834
Kurtosis	-0.80593963
Mean	49276328
Median Absolute Deviation (MAD)	12959100
Skewness	0.28204864
Sum	1.6888131 × 10¹³
Variance	5.0449894 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15101500	14584	4.2%
44103100	9457	2.7%
14111500	7190	2.1%
81112200	7026	2.0%
43211500	6974	2.0%
86101600	4951	1.4%
85101700	4478	1.3%
76122400	4458	1.3%
81111800	4122	1.2%
56101500	3980	1.2%
Other values (2353)	275503	79.6%

Value	Count	Frequency (%)
10101500	100	< 0.1%
10101600	21	< 0.1%
10101700	89	< 0.1%
10101800	7	< 0.1%
10101900	2	< 0.1%
10111300	18	< 0.1%
10121500	95	< 0.1%
10121600	119	< 0.1%
10121700	662	0.2%
10121800	12	< 0.1%

Value	Count	Frequency (%)
95141900	295	0.1%
95141800	80	< 0.1%
95141700	59	< 0.1%
95141600	10	< 0.1%
95141500	2	< 0.1%
95131700	26	< 0.1%
95131600	134	< 0.1%
95131500	4	< 0.1%
95122700	6	< 0.1%
95122500	4	< 0.1%

Class Title
Text

Distinct	2360
Distinct (%)	0.7%
Missing	3295
Missing (%)	1.0%
Memory size	2.6 MiB

Length

Max length	100
Median length	79
Mean length	28.290865
Min length	3

Characters and Unicode

Total characters	9695930
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	278 ?
Unique (%)	0.1%

Sample

1st row	Peppers
2nd row	Apples
3rd row	Printed publications
4th row	Livestock feed
5th row	Coffee and tea

Value	Count	Frequency (%)
and	216625	17.3%
services	44999	3.6%
accessories	25852	2.1%
equipment	22218	1.8%
supplies	20819	1.7%
software	15783	1.3%
support	15257	1.2%
products	14812	1.2%
petroleum	14588	1.2%
distillates	14584	1.2%
Other values (2496)	844531	67.6%

Most occurring characters

Value	Count	Frequency (%)
e	967534	10.0%
	907345	9.4%
i	773464	8.0%
n	770503	7.9%
a	760879	7.8%
s	752611	7.8%
t	633816	6.5%
r	609543	6.3%
o	489272	5.0%
c	426257	4.4%
Other values (44)	2604706	26.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	9695930	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	967534	10.0%
	907345	9.4%
i	773464	8.0%
n	770503	7.9%
a	760879	7.8%
s	752611	7.8%
t	633816	6.5%
r	609543	6.3%
o	489272	5.0%
c	426257	4.4%
Other values (44)	2604706	26.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	9695930	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	967534	10.0%
	907345	9.4%
i	773464	8.0%
n	770503	7.9%
a	760879	7.8%
s	752611	7.8%
t	633816	6.5%
r	609543	6.3%
o	489272	5.0%
c	426257	4.4%
Other values (44)	2604706	26.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	9695930	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	967534	10.0%
	907345	9.4%
i	773464	8.0%
n	770503	7.9%
a	760879	7.8%
s	752611	7.8%
t	633816	6.5%
r	609543	6.3%
o	489272	5.0%
c	426257	4.4%
Other values (44)	2604706	26.9%

Family
Real number (ℝ)

Distinct	409
Distinct (%)	0.1%
Missing	3295
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	49272189

Minimum	3018000
Maximum	95140000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	3018000
5-th percentile	14110000
Q1	39110000
median	44120000
Q3	71160000
95-th percentile	86100000
Maximum	95140000
Range	92122000
Interquartile range (IQR)	32050000

Descriptive statistics

Standard deviation	22464295
Coefficient of variation (CV)	0.45592241
Kurtosis	-0.80566174
Mean	49272189
Median Absolute Deviation (MAD)	12960000
Skewness	0.28158343
Sum	1.6886712 × 10¹³
Variance	5.0464456 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44100000	16479	4.8%
15100000	14599	4.2%
81110000	13946	4.0%
43210000	13851	4.0%
14110000	10772	3.1%
86100000	9785	2.8%
44120000	9342	2.7%
43230000	8274	2.4%
76120000	5433	1.6%
56100000	5177	1.5%
Other values (399)	235065	67.9%

Value	Count	Frequency (%)
3018000	28	< 0.1%
10100000	219	0.1%
10110000	18	< 0.1%
10120000	891	0.3%
10130000	53	< 0.1%
10140000	247	0.1%
10150000	691	0.2%
10160000	66	< 0.1%
10170000	725	0.2%
10190000	308	0.1%

Value	Count	Frequency (%)
95140000	446	0.1%
95130000	164	< 0.1%
95120000	315	0.1%
95110000	14	< 0.1%
95100000	14	< 0.1%
94130000	726	0.2%
94120000	65	< 0.1%
94110000	3	< 0.1%
94100000	123	< 0.1%
93170000	5	< 0.1%

Family Title
Text

Distinct	411
Distinct (%)	0.1%
Missing	3295
Missing (%)	1.0%
Memory size	2.6 MiB

Length

Max length	87
Median length	60
Mean length	29.268721
Min length	5

Characters and Unicode

Total characters	10031064
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Fresh vegetables
2nd row	Fresh fruits
3rd row	Printed media
4th row	Animal feed
5th row	Beverages

Value	Count	Frequency (%)
and	254171	19.6%
services	54130	4.2%
accessories	49177	3.8%
equipment	44553	3.4%
supplies	43741	3.4%
products	34703	2.7%
computer	27797	2.1%
office	27745	2.1%
or	21073	1.6%
machines	16651	1.3%
Other values (634)	725216	55.8%

Most occurring characters

Value	Count	Frequency (%)
e	1023173	10.2%
	956234	9.5%
a	788625	7.9%
i	775602	7.7%
s	774769	7.7%
n	773716	7.7%
r	630418	6.3%
t	600726	6.0%
o	505177	5.0%
c	470489	4.7%
Other values (39)	2732135	27.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	10031064	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1023173	10.2%
	956234	9.5%
a	788625	7.9%
i	775602	7.7%
s	774769	7.7%
n	773716	7.7%
r	630418	6.3%
t	600726	6.0%
o	505177	5.0%
c	470489	4.7%
Other values (39)	2732135	27.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	10031064	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1023173	10.2%
	956234	9.5%
a	788625	7.9%
i	775602	7.7%
s	774769	7.7%
n	773716	7.7%
r	630418	6.3%
t	600726	6.0%
o	505177	5.0%
c	470489	4.7%
Other values (39)	2732135	27.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	10031064	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1023173	10.2%
	956234	9.5%
a	788625	7.9%
i	775602	7.7%
s	774769	7.7%
n	773716	7.7%
r	630418	6.3%
t	600726	6.0%
o	505177	5.0%
c	470489	4.7%
Other values (39)	2732135	27.2%

Segment
Real number (ℝ)

Distinct	56
Distinct (%)	< 0.1%
Missing	3295
Missing (%)	1.0%
Infinite	0
Infinite (%)	0.0%
Mean	49132830

Minimum	10000000
Maximum	95000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.6 MiB

Quantile statistics

Minimum	10000000
5-th percentile	14000000
Q1	39000000
median	44000000
Q3	71000000
95-th percentile	86000000
Maximum	95000000
Range	85000000
Interquartile range (IQR)	32000000

Descriptive statistics

Standard deviation	22466364
Coefficient of variation (CV)	0.45725767
Kurtosis	-0.80651688
Mean	49132830
Median Absolute Deviation (MAD)	13000000
Skewness	0.28463721
Sum	1.6838951 × 10¹³
Variance	5.0473749 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43000000	32681	9.4%
50000000	27875	8.1%
44000000	27745	8.0%
81000000	17350	5.0%
42000000	16491	4.8%
15000000	16029	4.6%
14000000	11235	3.2%
25000000	10965	3.2%
86000000	10643	3.1%
46000000	10196	2.9%
Other values (46)	161513	46.7%

Value	Count	Frequency (%)
10000000	3299	1.0%
11000000	2203	0.6%
12000000	2402	0.7%
13000000	504	0.1%
14000000	11235	3.2%
15000000	16029	4.6%
20000000	3060	0.9%
21000000	548	0.2%
22000000	1372	0.4%
23000000	2920	0.8%

Value	Count	Frequency (%)
95000000	953	0.3%
94000000	917	0.3%
93000000	5724	1.7%
92000000	2168	0.6%
91000000	255	0.1%
90000000	1515	0.4%
86000000	10643	3.1%
85000000	7977	2.3%
84000000	1236	0.4%
83000000	1733	0.5%

Segment Title
Text

Distinct	56
Distinct (%)	< 0.1%
Missing	3295
Missing (%)	1.0%
Memory size	2.6 MiB

Length

Max length	127
Median length	70
Mean length	51.28523
Min length	18

Characters and Unicode

Total characters	17576628
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Food Beverage and Tobacco Products
2nd row	Food Beverage and Tobacco Products
3rd row	Published Products
4th row	Live Plant and Animal Material and Accessories and Supplies
5th row	Food Beverage and Tobacco Products

Value	Count	Frequency (%)
and	674964	29.9%
supplies	100666	4.5%
accessories	89765	4.0%
services	86795	3.8%
equipment	80191	3.6%
products	54558	2.4%
technology	50031	2.2%
materials	36415	1.6%
components	35958	1.6%
information	32681	1.4%
Other values (144)	1014922	45.0%

Most occurring characters

Value	Count	Frequency (%)
	1914223	10.9%
n	1640863	9.3%
e	1481553	8.4%
a	1447141	8.2%
i	1311748	7.5%
s	1050829	6.0%
d	954285	5.4%
o	869130	4.9%
r	865549	4.9%
c	845799	4.8%
Other values (36)	5195508	29.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	17576628	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1914223	10.9%
n	1640863	9.3%
e	1481553	8.4%
a	1447141	8.2%
i	1311748	7.5%
s	1050829	6.0%
d	954285	5.4%
o	869130	4.9%
r	865549	4.9%
c	845799	4.8%
Other values (36)	5195508	29.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	17576628	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1914223	10.9%
n	1640863	9.3%
e	1481553	8.4%
a	1447141	8.2%
i	1311748	7.5%
s	1050829	6.0%
d	954285	5.4%
o	869130	4.9%
r	865549	4.9%
c	845799	4.8%
Other values (36)	5195508	29.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	17576628	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1914223	10.9%
n	1640863	9.3%
e	1481553	8.4%
a	1447141	8.2%
i	1311748	7.5%
s	1050829	6.0%
d	954285	5.4%
o	869130	4.9%
r	865549	4.9%
c	845799	4.8%
Other values (36)	5195508	29.6%

Location
Text

Missing

Distinct	3993
Distinct (%)	1.4%
Missing	70110
Missing (%)	20.3%
Memory size	2.6 MiB

Length

Max length	35
Median length	30
Mean length	29.4052
Min length	4

Characters and Unicode

Total characters	8113130
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	742 ?
Unique (%)	0.3%

Sample

1st row	95841 (38.662263, -121.346136)
2nd row	91436 (34.151642, -118.49051)
3rd row	95814 (38.580427, -121.494396)
4th row	97008 (45.460518, -122.806409)
5th row	95814 (38.580427, -121.494396)

Value	Count	Frequency (%)
38.575311	11643	1.4%
121.560401	11643	1.4%
38.580427	11510	1.4%
121.494396	11510	1.4%
95691	11095	1.4%
95814	10921	1.3%
122.02	8518	1.0%
95696	8518	1.0%
38.43	8518	1.0%
121.328511	7159	0.9%
Other values (10596)	720425	87.7%

Most occurring characters

Value	Count	Frequency (%)
1	936712	11.5%
3	712585	8.8%
9	620962	7.7%
2	608096	7.5%
5	560846	6.9%
8	556014	6.9%
.	545412	6.7%
4	523946	6.5%
7	502781	6.2%
6	483033	6.0%
Other values (36)	2062743	25.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8113130	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	936712	11.5%
3	712585	8.8%
9	620962	7.7%
2	608096	7.5%
5	560846	6.9%
8	556014	6.9%
.	545412	6.7%
4	523946	6.5%
7	502781	6.2%
6	483033	6.0%
Other values (36)	2062743	25.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8113130	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	936712	11.5%
3	712585	8.8%
9	620962	7.7%
2	608096	7.5%
5	560846	6.9%
8	556014	6.9%
.	545412	6.7%
4	523946	6.5%
7	502781	6.2%
6	483033	6.0%
Other values (36)	2062743	25.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8113130	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	936712	11.5%
3	712585	8.8%
9	620962	7.7%
2	608096	7.5%
5	560846	6.9%
8	556014	6.9%
.	545412	6.7%
4	523946	6.5%
7	502781	6.2%
6	483033	6.0%
Other values (36)	2062743	25.4%

Interactions

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	Creation Date	Purchase Date	Fiscal Year	LPA Number	Purchase Order Number	Requisition Number	Acquisition Type	Sub-Acquisition Type	Acquisition Method	Sub-Acquisition Method	Department Name	Supplier Code	Supplier Name	Supplier Qualifications	Supplier Zip Code	CalCard	Item Name	Item Description	Quantity	Unit Price	Total Price	Classification Codes	Normalized UNSPSC	Commodity Title	Class	Class Title	Family	Family Title	Segment	Segment Title	Location
0	08/27/2013	NaN	2013-2014	7-12-70-26	REQ0011118	REQ0011118	IT Goods	NaN	WSCA/Coop	NaN	Consumer Affairs, Department of	1740272.0	Pitney Bowes	NaN	NaN	NO	USB	USB	1.0	$1.00	$1.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
1	01/29/2014	NaN	2013-2014	NaN	REQ0011932	REQ0011932	NON-IT Goods	NaN	Informal Competitive	NaN	Consumer Affairs, Department of	1760085.0	Rodea Auto Tech	NaN	NaN	NO	Tire Disposal	Tire Disposal	2.0	$2.00	$4.00	76121504	76121504.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
2	11/01/2013	NaN	2013-2014	NaN	REQ0011476	REQ0011476	IT Services	NaN	Informal Competitive	NaN	Consumer Affairs, Department of	17224.0	Smile Business Products, Inc	NaN	95841	NO	Labor	Labor	4.5	$150.00	$675.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	95841\n(38.662263, -121.346136)
3	06/13/2014	06/05/2014	2013-2014	NaN	4500236642	NaN	NON-IT Goods	NaN	Informal Competitive	NaN	Correctional Health Care Services	1754462.0	ASHAN INC	CA-MB CA-SB	91436	NO	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	91436\n(34.151642, -118.49051)
4	03/12/2014	03/12/2014	2013-2014	1-10-75-60A	4500221028	NaN	NON-IT Goods	NaN	Statewide Contract	NaN	Corrections and Rehabilitation, Department of	1087660.0	Technology Integration Group	NaN	95814	NO	Toner	Toner	1.0	$6080.26	$6080.26	44103127	44103127.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	95814\n(38.580427, -121.494396)
5	10/09/2014	10/01/2014	2014-2015	NaN	4500253427	NaN	NON-IT Goods	NaN	Informal Competitive	NaN	Correctional Health Care Services	1738777.0	WALGREENS SPECIALTY PHARMACY LLC	NaN	97008	NO	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	97008\n(45.460518, -122.806409)
6	10/10/2014	NaN	2014-2015	1-14-75-60A	REQ0013911	REQ0013911	NON-IT Goods	NaN	Statewide Contract	NaN	Consumer Affairs, Department of	1087660.0	Technology Integration Group	NaN	95814	NO	HP 35A BLACK TONER	HP 35A BLACK TONER	30.0	$45.40	$1362.00	44103127	44103127.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	95814\n(38.580427, -121.494396)
7	04/24/2014	04/14/2014	2013-2014	NaN	12-64006.01	NaN	NON-IT Services	Personal Services	Services are specifically exempt by statute	NaN	State Hospitals, Department of	1069280.0	David Gallardo	NaN	93274	NO	Radiation Oncology	Radiation Oncology	1.0	$400000.00	$400000.00	85121615	85121615.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	93274\n(36.193481, -119.358379)
8	02/06/2015	NaN	2014-2015	1-14-75-60A	REQ0014515	REQ0014515	NON-IT Goods	NaN	Statewide Contract	NaN	Consumer Affairs, Department of	1087660.0	Technology Integration Group	NaN	95814	NO	Black Toner Cartridge for CLJ 4700	Black Toner Cartridge for CLJ 4700	16.0	$127.06	$2032.96	44103127	44103127.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	95814\n(38.580427, -121.494396)
9	08/14/2013	07/26/2013	2013-2014	NaN	4500200308	NaN	NON-IT Goods	NaN	Informal Competitive	NaN	Water Resources, Department of	1014234.0	CLARKE SALES	NaN	91322	NO	1" ss 90* elbow , threaded	1" ss 90* elbow , threaded	4.0	$21.65	$86.60	401728	401728.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN	91322\n(34.379263, -118.547301)

	Creation Date	Purchase Date	Fiscal Year	LPA Number	Purchase Order Number	Requisition Number	Acquisition Type	Sub-Acquisition Type	Acquisition Method	Sub-Acquisition Method	Department Name	Supplier Code	Supplier Name	Supplier Qualifications	Supplier Zip Code	CalCard	Item Name	Item Description	Quantity	Unit Price	Total Price	Classification Codes	Normalized UNSPSC	Commodity Title	Class	Class Title	Family	Family Title	Segment	Segment Title	Location
346008	11/28/2012	NaN	2012-2013	NaN	1026	NaN	NON-IT Goods	NaN	NCB	NaN	Highway Patrol, California	1732038.0	Commercial Vehicle Safety Alliance	NaN	20770	NO	Commercial Vehicle Safety Alliance (CVSA) Decals - Orange, 3rd Qtr. of 2013	For delivery in 3rd qtr. of 2013 (Jul, Aug, Sep)	135000.0	$0.28	$37800.00	55121607	55121607.0	Decals	55121600.0	Labels	55120000.0	Signage and accessories	55000000.0	Published Products	20770\n(39.000196, -76.882952)
346009	05/10/2013	07/01/2013	2012-2013	NaN	3169558	NaN	NON-IT Services	Legal Services	Services are specifically exempt by statute	NaN	General Services, Department of	1135461.0	Michael Diliberto	NaN	90067	NO	SE Pro Tem Services	Contractor will provide services as a Pro Tem ALJ during Special\nEducation hearings and mediations.	1.0	$25000.00	$25000.00	93151507	93151507.0	Administrative procedures or services	93151500.0	Public administration	93150000.0	Public administration and finance services	93000000.0	Politics and Civic Affairs Services	90067\n(34.057398, -118.414336)
346010	06/17/2014	06/05/2014	2013-2014	NaN	P1475034	NaN	NON-IT Services	Nonprofit Organizations	Informal Competitive	NaN	Fish and Wildlife, Department of	1086212.0	Marine Exchange of Southern California	NaN	90733	NO	Grant	Harbor Safety Committee Secretariat Services	1.0	$51268.60	$51268.60	77131502	77131502.0	Oil spillage control services	77131500.0	Oil pollution	77130000.0	Pollutants tracking and monitoring and rehabilitation services	77000000.0	Environmental Services	90733\n(33.735802, -118.291397)
346011	07/30/2013	07/30/2013	2013-2014	1-11-70-04O	4500192139	NaN	IT Services	NaN	Statewide Contract	NaN	Corrections and Rehabilitation, Department of	17224.0	Smile Business Products, Inc	NaN	95841	NO	Copier Maintenance	Copier Maintenance	8.0	$2600.00	$20800.00	81112201	81112201.0	Maintenance or support fees	81112200.0	Software maintenance and support	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95841\n(38.662263, -121.346136)
346012	12/31/2013	12/31/2013	2013-2014	NaN	P1300585	NaN	NON-IT Goods	NaN	Fair and Reasonable	NaN	Franchise Tax Board	59158.0	Flash Business Solutions	CA-MB CA-SB	95763-1046	NO	forms	Report of Deposit forms	1.0	$2548.80	$2548.80	14111806	14111806.0	Business forms or questionnaires	14111800.0	Business use papers	14110000.0	Paper products	14000000.0	Paper Materials and Products	95763-1046\n(38.681325, -121.163738)
346013	11/03/2014	09/25/2014	2014-2015	NaN	4500252536	NaN	NON-IT Goods	NaN	Informal Competitive	NaN	Corrections and Rehabilitation, Department of	12205.0	Superior Produce, Inc.	CA-SB	95811	NO	Inmate feeding: Oct. produce order, 2nd quar.	Inmate feeding: Oct. produce order, 2nd quar.	1.0	$37479.45	$37479.45	93131608	93131608.0	Food supply services	93131600.0	Food and nutrition policy planning and programs	93130000.0	Humanitarian aid and relief	93000000.0	Politics and Civic Affairs Services	95811\n(38.581053, -121.488564)
346014	08/14/2014	07/20/2011	2014-2015	NaN	10A1343	NaN	NON-IT Services	Expert Witneses	Services are specifically exempt by statute	NaN	Transportation, Department of	1018638.0	CONFIDENTIAL - Information Withheld	NaN	95816	NO	Expert Witness	Expert Witness Real Estate Appraisals - Amendment for additional funds.	1.0	$35000.00	$35000.00	80121903	80121903.0	Expert witness service	80121900.0	Compensated legal participation services	80120000.0	Legal services	80000000.0	Management and Business Professionals and Administrative Services	95816\n(38.57219, -121.467691)
346015	05/09/2014	NaN	2013-2014	NaN	228	NaN	IT Goods	NaN	SB/DVBE Option	NaN	High Speed Rail Authority, California	1136849.0	Straight-Line Solutions	CA-MB CA-SB	95829	NO	Inout Panel Cover	Projector accessories	2.0	$49.99	$99.98	45111609\n56101710	45111609.0	Multimedia projectors	45111600.0	Projectors and supplies	45110000.0	Audio and visual presentation and composing equipment	45000000.0	Printing and Photographic and Audio and Visual Equipment and Supplies	95829\n(38.474725, -121.340819)
346016	01/14/2014	01/14/2014	2013-2014	NaN	P1300614	NaN	NON-IT Goods	NaN	Fair and Reasonable	NaN	Franchise Tax Board	8329.0	Merritt Business Supplies	CA-MB CA-SB	95630	NO	Dremel 120 Volt Engraver	Dremel 120 Volt Engraver	1.0	$35.00	$35.00	27112718	27112718.0	Engravers	27112700.0	Power tools	27110000.0	Hand tools	27000000.0	Tools and General Machinery	95630\n(38.670213, -121.147592)
346017	10/09/2013	09/09/2013	2013-2014	NaN	2ui3L262	NaN	NON-IT Services	Contracts with Local Governments	Emergency Purchase	NaN	Forestry and Fire Protection, Department of	1050481.0	Happy Valley Fire Protection District	NaN	96007	NO	LOCAL GOVERNMENT-LABOR	Local government engines on going fire "Clover"	1.0	$17455.91	$17455.91	76122405	76122405.0	Labor fee	76122400.0	Refuse disposal and treatment fees	76120000.0	Refuse disposal and treatment	76000000.0	Industrial Cleaning Services	96007\n(40.456408, -122.315294)

Duplicate rows

Most frequently occurring

	Creation Date	Purchase Date	Fiscal Year	LPA Number	Purchase Order Number	Requisition Number	Acquisition Type	Sub-Acquisition Type	Acquisition Method	Sub-Acquisition Method	Department Name	Supplier Code	Supplier Name	Supplier Qualifications	Supplier Zip Code	CalCard	Item Name	Item Description	Quantity	Unit Price	Total Price	Classification Codes	Normalized UNSPSC	Commodity Title	Class	Class Title	Family	Family Title	Segment	Segment Title	Location	# duplicates
409	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	UPS Network Management Card 2	Network Maintenance	1.0	$512.55	$512.55	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	25
404	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	Trustwave X100 Appliance	Network Maintenance	1.0	$4500.00	$4500.00	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	24
326	04/08/2015	04/01/2015	2014-2015	NaN	4500221608	NaN	NON-IT Goods	NaN	Informal Competitive	NaN	Water Resources, Department of	35423.0	Cal Best Industrial Supply	CA-MB CA-SB	93308	NO	PANTS,ARC/FLASH	PANTS,ARC/FLASH	3.0	$72.00	$216.00	46181518	46181518.0	Heat resistant clothing	46181500.0	Safety apparel	46180000.0	Personal safety and protection	46000000.0	Defense and Law Enforcement and Security and Safety Equipment and Supplies	93308\n(35.485441, -119.013391)	22
379	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	APC 2 Post Mounting Kit for Smart UPS and Symmetra	Network Maintenance	2.0	$181.05	$362.10	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	22
390	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	Cisco 3945 W/SPE 150	Includes:\n Cisco AC Power Supply\n AC Power Cord\n Cisco Services Performance Engin 150 for Cisco\n IP Base License for Cisco\n Cisco Fan Assembly\n Cisco Config Pro Express on Router Flash\n 1GB DRAM\n 256 Compact Flash for Cisco\n Cisco IOS Un	1.0	$6500.00	$6500.00	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	22
387	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	APC Smart UPS X2000VA Rack Tower LCd	Network Maintenance	1.0	$1568.25	$1568.25	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	20
396	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	Cradlepoint ARC CBA750B Wireless Router	Network Maintenance	1.0	$599.00	$599.00	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	17
400	04/21/2015	01/29/2015	2014-2015	5-06-58-20	CF140541	NaN	IT Services	NaN	Master Service Agreement	NaN	Forestry and Fire Protection, Department of	1000530.0	AT&T	NaN	95134	NO	One Port T3 Network Module	Network Maintenance	1.0	$4675.00	$4675.00	81111804	81111804.0	Wide area network WAN maintenance or support	81111800.0	System and system component administration services	81110000.0	Computer services	81000000.0	Engineering and Research and Technology Based Services	95134\n(37.410635, -121.940949)	17
63	01/10/2014	01/08/2014	2013-2014	NaN	4500206131	NaN	NON-IT Services	Agreements with other governmental entities and public universities	Services are specifically exempt by policy	NaN	Water Resources, Department of	1117701.0	South Coast Air Quality Management District	NaN	91765	NO	AV AQMD Fee	AV AQMD Fee	1.0	$224.29	$224.29	93151516	93151516.0	Building permit	93151500.0	Public administration	93150000.0	Public administration and finance services	93000000.0	Politics and Civic Affairs Services	91765\n(33.997935, -117.817436)	16
106	01/28/2015	01/27/2015	2014-2015	NaN	4500219416	NaN	NON-IT Goods	NaN	Informal Competitive	NaN	Water Resources, Department of	6523.0	IBHP INCORPORATED	CA-SB	98733	NO	PANTS,ARC/FLASH	PANTS,ARC/FLASH	2.0	$51.50	$103.00	46181518	46181518.0	Heat resistant clothing	46181500.0	Safety apparel	46180000.0	Personal safety and protection	46000000.0	Defense and Law Enforcement and Security and Safety Equipment and Supplies	98733\n	14

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)